Overview
Brought to you by YData
Dataset statistics
| Number of variables | 23 |
|---|---|
| Number of observations | 103076 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 159 |
| Duplicate rows (%) | 0.2% |
| Total size in memory | 18.1 MiB |
| Average record size in memory | 184.0 B |
Variable types
| Categorical | 4 |
|---|---|
| Text | 2 |
| DateTime | 1 |
| Numeric | 16 |
| Dataset has 159 (0.2%) duplicate rows | Duplicates |
Average_Rating is highly overall correlated with Hotel_Name and 5 other fields | High correlation |
Breadth is highly overall correlated with Depth | High correlation |
Crawled_date is highly overall correlated with Hotel_Name and 1 other fields | High correlation |
Depth is highly overall correlated with Breadth | High correlation |
Hotel_Name is highly overall correlated with Average_Rating and 9 other fields | High correlation |
Num_of_Ratings is highly overall correlated with Hotel_Name and 1 other fields | High correlation |
cleanliness_score is highly overall correlated with Average_Rating and 6 other fields | High correlation |
comfort_score is highly overall correlated with Average_Rating and 5 other fields | High correlation |
employee_friendliness_score is highly overall correlated with Average_Rating and 5 other fields | High correlation |
facility_score is highly overall correlated with Average_Rating and 6 other fields | High correlation |
hotel_grade is highly overall correlated with Hotel_Name and 3 other fields | High correlation |
location_score is highly overall correlated with Hotel_Name | High correlation |
value_for_money_score is highly overall correlated with Average_Rating and 6 other fields | High correlation |
is_photo is highly imbalanced (71.7%) | Imbalance |
Crawled_date is highly imbalanced (87.7%) | Imbalance |
Helpfulness has 93909 (91.1%) zeros | Zeros |
Deviation.of.star.ratings has 2958 (2.9%) zeros | Zeros |
Reproduction
| Analysis started | 2025-01-08 14:58:52.936654 |
|---|---|
| Analysis finished | 2025-01-08 14:59:20.887260 |
| Duration | 27.95 seconds |
| Software version | ydata-profiling vv4.12.0 |
| Download configuration | config.json |
Variables
Hotel_Name
Categorical
High correlation
| Distinct | 33 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 805.4 KiB |
| blakemore | 4940 |
|---|---|
| park-plaza-county-hall | 4929 |
| milleniumgloucester | 4919 |
| zedwell-trocaderor | 4909 |
| lancaster-gate | 4907 |
| Other values (28) |
Length
| Max length | 35 |
|---|---|
| Median length | 22 |
| Mean length | 15.898424 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | studios2let |
|---|---|
| 2nd row | studios2let |
| 3rd row | studios2let |
| 4th row | studios2let |
| 5th row | studios2let |
Common Values
| Value | Count | Frequency (%) |
| blakemore | 4940 | 4.8% |
| park-plaza-county-hall | 4929 | 4.8% |
| milleniumgloucester | 4919 | 4.8% |
| zedwell-trocaderor | 4909 | 4.8% |
| lancaster-gate | 4907 | 4.8% |
| thistletower | 4888 | 4.7% |
| stgileshotel | 4874 | 4.7% |
| z-trafalgar | 4728 | 4.6% |
| marlin-waterloo | 4334 | 4.2% |
| nyx-hotel-london-by-leonardo-hotels | 3725 | 3.6% |
| Other values (23) | 55923 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| blakemore | 4940 | 4.8% |
| park-plaza-county-hall | 4929 | 4.8% |
| milleniumgloucester | 4919 | 4.8% |
| zedwell-trocaderor | 4909 | 4.8% |
| lancaster-gate | 4907 | 4.8% |
| thistletower | 4888 | 4.7% |
| stgileshotel | 4874 | 4.7% |
| z-trafalgar | 4728 | 4.6% |
| marlin-waterloo | 4334 | 4.2% |
| nyx-hotel-london-by-leonardo-hotels | 3725 | 3.6% |
| Other values (23) | 55923 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 174901 | |
| o | 161413 | 9.8% |
| t | 158482 | 9.7% |
| l | 150614 | 9.2% |
| a | 125519 | 7.7% |
| r | 116000 | 7.1% |
| n | 95427 | 5.8% |
| s | 87823 | 5.4% |
| - | 84284 | 5.1% |
| i | 72550 | 4.4% |
| Other values (16) | 411733 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1638746 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 174901 | |
| o | 161413 | 9.8% |
| t | 158482 | 9.7% |
| l | 150614 | 9.2% |
| a | 125519 | 7.7% |
| r | 116000 | 7.1% |
| n | 95427 | 5.8% |
| s | 87823 | 5.4% |
| - | 84284 | 5.1% |
| i | 72550 | 4.4% |
| Other values (16) | 411733 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1638746 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 174901 | |
| o | 161413 | 9.8% |
| t | 158482 | 9.7% |
| l | 150614 | 9.2% |
| a | 125519 | 7.7% |
| r | 116000 | 7.1% |
| n | 95427 | 5.8% |
| s | 87823 | 5.4% |
| - | 84284 | 5.1% |
| i | 72550 | 4.4% |
| Other values (16) | 411733 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1638746 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 174901 | |
| o | 161413 | 9.8% |
| t | 158482 | 9.7% |
| l | 150614 | 9.2% |
| a | 125519 | 7.7% |
| r | 116000 | 7.1% |
| n | 95427 | 5.8% |
| s | 87823 | 5.4% |
| - | 84284 | 5.1% |
| i | 72550 | 4.4% |
| Other values (16) | 411733 |
Review_Text
Text
| Distinct | 92513 |
|---|---|
| Distinct (%) | 89.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 805.4 KiB |
Length
| Max length | 3534 |
|---|---|
| Median length | 1868 |
| Mean length | 208.59817 |
| Min length | 3 |
Unique
| Unique | 91987 ? |
|---|---|
| Unique (%) | 89.2% |
Sample
| 1st row | Perfect location with good connections and shops and pubs |
|---|---|
| 2nd row | The room had everything you needed Near to amenities, was good room for price just needs little updatingThe bed was so hard it felt like sleeping on a hard floor, you had to make sure you had something on your feet as flooring pinched you feet needs changing |
| 3rd row | Conveniently nearby St Pancras, very small but clean and pleasant room first floor with small balcony to street side Interesting areaLuggage service can be improved by offering to lock luggage up instead of it just being put into the hall with all risks on the guests |
| 4th row | Reception staffed 24 hours a dayAll good |
| 5th row | Very convenient to Kings Cross and the cityA little dated could do with a lick of paint |
| Value | Count | Frequency (%) |
| the | 212453 | 5.6% |
| and | 145876 | 3.8% |
| was | 122295 | 3.2% |
| to | 97348 | 2.5% |
| a | 90768 | 2.4% |
| room | 73085 | 1.9% |
| in | 64514 | 1.7% |
| very | 53636 | 1.4% |
| for | 50886 | 1.3% |
| of | 49457 | 1.3% |
| Other values (68127) | 2867604 |
Most occurring characters
| Value | Count | Frequency (%) |
| 3745873 | ||
| e | 2063096 | 9.6% |
| o | 1592601 | 7.4% |
| t | 1541090 | 7.2% |
| a | 1479756 | 6.9% |
| n | 1145021 | 5.3% |
| r | 1048825 | 4.9% |
| i | 1025214 | 4.8% |
| s | 961241 | 4.5% |
| l | 822258 | 3.8% |
| Other values (58) | 6076490 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 21501465 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 3745873 | ||
| e | 2063096 | 9.6% |
| o | 1592601 | 7.4% |
| t | 1541090 | 7.2% |
| a | 1479756 | 6.9% |
| n | 1145021 | 5.3% |
| r | 1048825 | 4.9% |
| i | 1025214 | 4.8% |
| s | 961241 | 4.5% |
| l | 822258 | 3.8% |
| Other values (58) | 6076490 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 21501465 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 3745873 | ||
| e | 2063096 | 9.6% |
| o | 1592601 | 7.4% |
| t | 1541090 | 7.2% |
| a | 1479756 | 6.9% |
| n | 1145021 | 5.3% |
| r | 1048825 | 4.9% |
| i | 1025214 | 4.8% |
| s | 961241 | 4.5% |
| l | 822258 | 3.8% |
| Other values (58) | 6076490 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 21501465 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 3745873 | ||
| e | 2063096 | 9.6% |
| o | 1592601 | 7.4% |
| t | 1541090 | 7.2% |
| a | 1479756 | 6.9% |
| n | 1145021 | 5.3% |
| r | 1048825 | 4.9% |
| i | 1025214 | 4.8% |
| s | 961241 | 4.5% |
| l | 822258 | 3.8% |
| Other values (58) | 6076490 |
Posted_Date
Date
| Distinct | 1107 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 805.4 KiB |
| Minimum | 2021-12-01 00:00:00 |
|---|---|
| Maximum | 2024-12-13 00:00:00 |
Histogram with fixed size bins (bins=50)
Rating
Real number (ℝ)
| Distinct | 25 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.7423522 |
| Minimum | 1 |
|---|---|
| Maximum | 10 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 805.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 4 |
| Q1 | 7 |
| median | 8 |
| Q3 | 9 |
| 95-th percentile | 10 |
| Maximum | 10 |
| Range | 9 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.8768098 |
|---|---|
| Coefficient of variation (CV) | 0.24240822 |
| Kurtosis | 2.2077181 |
| Mean | 7.7423522 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | -1.3245229 |
| Sum | 798050.7 |
| Variance | 3.5224151 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=25)
| Value | Count | Frequency (%) |
| 8 | 31625 | |
| 9 | 19014 | |
| 10 | 17137 | |
| 7 | 17064 | |
| 6 | 7131 | 6.9% |
| 5 | 4277 | 4.1% |
| 4 | 2374 | 2.3% |
| 3 | 1800 | 1.7% |
| 1 | 1704 | 1.7% |
| 2 | 878 | 0.9% |
| Other values (15) | 72 | 0.1% |
| Value | Count | Frequency (%) |
| 1 | 1704 | 1.7% |
| 2 | 878 | 0.9% |
| 2.5 | 1 | < 0.1% |
| 2.9 | 1 | < 0.1% |
| 3 | 1800 | |
| 3.8 | 1 | < 0.1% |
| 4 | 2374 | |
| 4.6 | 1 | < 0.1% |
| 5 | 4277 | |
| 5.4 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 10 | 17137 | |
| 9.6 | 15 | < 0.1% |
| 9.2 | 12 | < 0.1% |
| 9 | 19014 | |
| 8.8 | 7 | < 0.1% |
| 8.3 | 8 | < 0.1% |
| 8 | 31625 | |
| 7.9 | 7 | < 0.1% |
| 7.5 | 5 | < 0.1% |
| 7.1 | 3 | < 0.1% |
Average_Rating
Real number (ℝ)
High correlation
| Distinct | 15 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.8543851 |
| Minimum | 7 |
|---|---|
| Maximum | 8.7 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 805.4 KiB |
Quantile statistics
| Minimum | 7 |
|---|---|
| 5-th percentile | 7 |
| Q1 | 7.6 |
| median | 7.8 |
| Q3 | 8.2 |
| 95-th percentile | 8.6 |
| Maximum | 8.7 |
| Range | 1.7 |
| Interquartile range (IQR) | 0.6 |
Descriptive statistics
| Standard deviation | 0.43634279 |
|---|---|
| Coefficient of variation (CV) | 0.055554036 |
| Kurtosis | -0.50902763 |
| Mean | 7.8543851 |
| Median Absolute Deviation (MAD) | 0.3 |
| Skewness | 0.031159136 |
| Sum | 809598.6 |
| Variance | 0.19039503 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=15)
| Value | Count | Frequency (%) |
| 7.7 | 23014 | |
| 7.4 | 9828 | |
| 7.8 | 9262 | |
| 8.4 | 8453 | 8.2% |
| 7.9 | 7817 | 7.6% |
| 8.3 | 7485 | 7.3% |
| 8.6 | 6873 | 6.7% |
| 7 | 6849 | 6.6% |
| 7.6 | 5479 | 5.3% |
| 8 | 5153 | 5.0% |
| Other values (5) | 12863 |
| Value | Count | Frequency (%) |
| 7 | 6849 | 6.6% |
| 7.1 | 1995 | 1.9% |
| 7.4 | 9828 | |
| 7.5 | 2157 | 2.1% |
| 7.6 | 5479 | 5.3% |
| 7.7 | 23014 | |
| 7.8 | 9262 | |
| 7.9 | 7817 | 7.6% |
| 8 | 5153 | 5.0% |
| 8.1 | 4334 | 4.2% |
| Value | Count | Frequency (%) |
| 8.7 | 2562 | 2.5% |
| 8.6 | 6873 | 6.7% |
| 8.4 | 8453 | 8.2% |
| 8.3 | 7485 | 7.3% |
| 8.2 | 1815 | 1.8% |
| 8.1 | 4334 | 4.2% |
| 8 | 5153 | 5.0% |
| 7.9 | 7817 | 7.6% |
| 7.8 | 9262 | |
| 7.7 | 23014 |
Num_of_Ratings
Real number (ℝ)
High correlation
| Distinct | 34 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11857.156 |
| Minimum | 5613 |
|---|---|
| Maximum | 39497 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 805.4 KiB |
Quantile statistics
| Minimum | 5613 |
|---|---|
| 5-th percentile | 5898 |
| Q1 | 7132 |
| median | 9767 |
| Q3 | 13923 |
| 95-th percentile | 20956 |
| Maximum | 39497 |
| Range | 33884 |
| Interquartile range (IQR) | 6791 |
Descriptive statistics
| Standard deviation | 7266.1052 |
|---|---|
| Coefficient of variation (CV) | 0.61280339 |
| Kurtosis | 7.2025689 |
| Mean | 11857.156 |
| Median Absolute Deviation (MAD) | 3252 |
| Skewness | 2.580654 |
| Sum | 1.2221882 × 109 |
| Variance | 52796285 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=34)
| Value | Count | Frequency (%) |
| 12340 | 4940 | 4.8% |
| 11045 | 4929 | 4.8% |
| 15320 | 4919 | 4.8% |
| 39497 | 4909 | 4.8% |
| 14445 | 4907 | 4.8% |
| 20956 | 4888 | 4.7% |
| 14989 | 4874 | 4.7% |
| 13923 | 4728 | 4.6% |
| 10695 | 4334 | 4.2% |
| 9394 | 3725 | 3.6% |
| Other values (24) | 55923 |
| Value | Count | Frequency (%) |
| 5613 | 1884 | |
| 5715 | 1944 | |
| 5898 | 1815 | |
| 5932 | 2188 | |
| 5933 | 2362 | |
| 6120 | 2036 | |
| 6248 | 1735 | |
| 6277 | 2401 | |
| 6335 | 2117 | |
| 6404 | 1975 |
| Value | Count | Frequency (%) |
| 39497 | 4909 | |
| 20956 | 4888 | |
| 15320 | 4919 | |
| 14989 | 4874 | |
| 14445 | 4907 | |
| 13923 | 4728 | |
| 12641 | 3492 | |
| 12340 | 4940 | |
| 11670 | 3443 | |
| 11045 | 4929 |
Helpfulness
Real number (ℝ)
Zeros
| Distinct | 11 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.10376809 |
| Minimum | 0 |
|---|---|
| Maximum | 14 |
| Zeros | 93909 |
| Zeros (%) | 91.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 805.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 14 |
| Range | 14 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.36788488 |
|---|---|
| Coefficient of variation (CV) | 3.54526 |
| Kurtosis | 60.563756 |
| Mean | 0.10376809 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 5.3449878 |
| Sum | 10696 |
| Variance | 0.13533928 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=11)
| Value | Count | Frequency (%) |
| 0 | 93909 | |
| 1 | 8004 | 7.8% |
| 2 | 930 | 0.9% |
| 3 | 163 | 0.2% |
| 4 | 38 | < 0.1% |
| 5 | 20 | < 0.1% |
| 6 | 7 | < 0.1% |
| 10 | 2 | < 0.1% |
| 7 | 1 | < 0.1% |
| 14 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 93909 | |
| 1 | 8004 | 7.8% |
| 2 | 930 | 0.9% |
| 3 | 163 | 0.2% |
| 4 | 38 | < 0.1% |
| 5 | 20 | < 0.1% |
| 6 | 7 | < 0.1% |
| 7 | 1 | < 0.1% |
| 8 | 1 | < 0.1% |
| 10 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 14 | 1 | < 0.1% |
| 10 | 2 | < 0.1% |
| 8 | 1 | < 0.1% |
| 7 | 1 | < 0.1% |
| 6 | 7 | < 0.1% |
| 5 | 20 | < 0.1% |
| 4 | 38 | < 0.1% |
| 3 | 163 | 0.2% |
| 2 | 930 | 0.9% |
| 1 | 8004 |
is_photo
Categorical
Imbalance
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 805.4 KiB |
| 0 | |
|---|---|
| 1 | 5079 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 97997 | |
| 1 | 5079 | 4.9% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 97997 | |
| 1 | 5079 | 4.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 97997 | |
| 1 | 5079 | 4.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 103076 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 97997 | |
| 1 | 5079 | 4.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 103076 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 97997 | |
| 1 | 5079 | 4.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 103076 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 97997 | |
| 1 | 5079 | 4.9% |
review_title
Text
| Distinct | 52445 |
|---|---|
| Distinct (%) | 50.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 805.4 KiB |
Length
| Max length | 120 |
|---|---|
| Median length | 103 |
| Mean length | 31.436581 |
| Min length | 1 |
Unique
| Unique | 50032 ? |
|---|---|
| Unique (%) | 48.5% |
Sample
| 1st row | Exceptional |
|---|---|
| 2nd row | Very good |
| 3rd row | Convenient location |
| 4th row | Peaceful position in an elegant street close to 3 major stations and the Bloomsbury area |
| 5th row | Great little gem in the city centre |
| Value | Count | Frequency (%) |
| good | 28921 | 5.1% |
| location | 19660 | 3.5% |
| and | 19512 | 3.5% |
| very | 18418 | 3.3% |
| stay | 17046 | 3.0% |
| great | 16452 | 2.9% |
| a | 16229 | 2.9% |
| for | 13650 | 2.4% |
| the | 13547 | 2.4% |
| hotel | 12795 | 2.3% |
| Other values (10993) | 388161 |
Most occurring characters
| Value | Count | Frequency (%) |
| 467085 | ||
| e | 303408 | 9.4% |
| o | 284348 | 8.8% |
| a | 245299 | 7.6% |
| t | 237297 | 7.3% |
| n | 182869 | 5.6% |
| l | 157996 | 4.9% |
| r | 156002 | 4.8% |
| i | 150315 | 4.6% |
| s | 114817 | 3.5% |
| Other values (56) | 940921 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3240357 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 467085 | ||
| e | 303408 | 9.4% |
| o | 284348 | 8.8% |
| a | 245299 | 7.6% |
| t | 237297 | 7.3% |
| n | 182869 | 5.6% |
| l | 157996 | 4.9% |
| r | 156002 | 4.8% |
| i | 150315 | 4.6% |
| s | 114817 | 3.5% |
| Other values (56) | 940921 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3240357 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 467085 | ||
| e | 303408 | 9.4% |
| o | 284348 | 8.8% |
| a | 245299 | 7.6% |
| t | 237297 | 7.3% |
| n | 182869 | 5.6% |
| l | 157996 | 4.9% |
| r | 156002 | 4.8% |
| i | 150315 | 4.6% |
| s | 114817 | 3.5% |
| Other values (56) | 940921 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3240357 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 467085 | ||
| e | 303408 | 9.4% |
| o | 284348 | 8.8% |
| a | 245299 | 7.6% |
| t | 237297 | 7.3% |
| n | 182869 | 5.6% |
| l | 157996 | 4.9% |
| r | 156002 | 4.8% |
| i | 150315 | 4.6% |
| s | 114817 | 3.5% |
| Other values (56) | 940921 |
hotel_grade
Categorical
High correlation
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 805.4 KiB |
| 4 | |
|---|---|
| 3 | |
| 5 | |
| 0 | 4909 |
| 2 | 2151 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 3 |
|---|---|
| 2nd row | 3 |
| 3rd row | 3 |
| 4th row | 3 |
| 5th row | 3 |
Common Values
| Value | Count | Frequency (%) |
| 4 | 50093 | |
| 3 | 38828 | |
| 5 | 7095 | 6.9% |
| 0 | 4909 | 4.8% |
| 2 | 2151 | 2.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 4 | 50093 | |
| 3 | 38828 | |
| 5 | 7095 | 6.9% |
| 0 | 4909 | 4.8% |
| 2 | 2151 | 2.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 4 | 50093 | |
| 3 | 38828 | |
| 5 | 7095 | 6.9% |
| 0 | 4909 | 4.8% |
| 2 | 2151 | 2.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 103076 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 4 | 50093 | |
| 3 | 38828 | |
| 5 | 7095 | 6.9% |
| 0 | 4909 | 4.8% |
| 2 | 2151 | 2.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 103076 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 4 | 50093 | |
| 3 | 38828 | |
| 5 | 7095 | 6.9% |
| 0 | 4909 | 4.8% |
| 2 | 2151 | 2.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 103076 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 4 | 50093 | |
| 3 | 38828 | |
| 5 | 7095 | 6.9% |
| 0 | 4909 | 4.8% |
| 2 | 2151 | 2.1% |
employee_friendliness_score
Real number (ℝ)
High correlation
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.5369029 |
| Minimum | 7.5 |
|---|---|
| Maximum | 9.1 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 805.4 KiB |
Quantile statistics
| Minimum | 7.5 |
|---|---|
| 5-th percentile | 8 |
| Q1 | 8.3 |
| median | 8.6 |
| Q3 | 8.7 |
| 95-th percentile | 9.1 |
| Maximum | 9.1 |
| Range | 1.6 |
| Interquartile range (IQR) | 0.4 |
Descriptive statistics
| Standard deviation | 0.36805694 |
|---|---|
| Coefficient of variation (CV) | 0.043113638 |
| Kurtosis | 0.57229583 |
| Mean | 8.5369029 |
| Median Absolute Deviation (MAD) | 0.2 |
| Skewness | -0.6845645 |
| Sum | 879949.8 |
| Variance | 0.13546591 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=12)
| Value | Count | Frequency (%) |
| 8.7 | 21129 | |
| 8.6 | 15348 | |
| 8.1 | 9783 | |
| 8.4 | 9325 | |
| 9.1 | 9234 | |
| 8.5 | 8860 | |
| 9 | 8479 | |
| 8.3 | 5600 | 5.4% |
| 8 | 4919 | 4.8% |
| 8.8 | 4312 | 4.2% |
| Other values (2) | 6087 | 5.9% |
| Value | Count | Frequency (%) |
| 7.5 | 3970 | 3.9% |
| 8 | 4919 | 4.8% |
| 8.1 | 9783 | |
| 8.2 | 2117 | 2.1% |
| 8.3 | 5600 | 5.4% |
| 8.4 | 9325 | |
| 8.5 | 8860 | |
| 8.6 | 15348 | |
| 8.7 | 21129 | |
| 8.8 | 4312 | 4.2% |
| Value | Count | Frequency (%) |
| 9.1 | 9234 | |
| 9 | 8479 | |
| 8.8 | 4312 | 4.2% |
| 8.7 | 21129 | |
| 8.6 | 15348 | |
| 8.5 | 8860 | |
| 8.4 | 9325 | |
| 8.3 | 5600 | 5.4% |
| 8.2 | 2117 | 2.1% |
| 8.1 | 9783 |
facility_score
Real number (ℝ)
High correlation
| Distinct | 17 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.8648415 |
| Minimum | 6.9 |
|---|---|
| Maximum | 8.7 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 805.4 KiB |
Quantile statistics
| Minimum | 6.9 |
|---|---|
| 5-th percentile | 6.9 |
| Q1 | 7.5 |
| median | 7.8 |
| Q3 | 8.3 |
| 95-th percentile | 8.7 |
| Maximum | 8.7 |
| Range | 1.8 |
| Interquartile range (IQR) | 0.8 |
Descriptive statistics
| Standard deviation | 0.50545226 |
|---|---|
| Coefficient of variation (CV) | 0.064267317 |
| Kurtosis | -0.80286885 |
| Mean | 7.8648415 |
| Median Absolute Deviation (MAD) | 0.3 |
| Skewness | 0.024449694 |
| Sum | 810676.4 |
| Variance | 0.25548198 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=17)
| Value | Count | Frequency (%) |
| 7.8 | 12677 | |
| 7.5 | 12543 | |
| 8.7 | 11216 | |
| 7.6 | 9227 | |
| 8.3 | 8036 | 7.8% |
| 6.9 | 6849 | 6.6% |
| 8 | 6724 | 6.5% |
| 7.4 | 4919 | 4.8% |
| 7.2 | 4909 | 4.8% |
| 8.4 | 4728 | 4.6% |
| Other values (7) | 21248 |
| Value | Count | Frequency (%) |
| 6.9 | 6849 | |
| 7.2 | 4909 | 4.8% |
| 7.3 | 1995 | 1.9% |
| 7.4 | 4919 | 4.8% |
| 7.5 | 12543 | |
| 7.6 | 9227 | |
| 7.7 | 4136 | 4.0% |
| 7.8 | 12677 | |
| 7.9 | 2362 | 2.3% |
| 8 | 6724 |
| Value | Count | Frequency (%) |
| 8.7 | 11216 | |
| 8.6 | 1944 | 1.9% |
| 8.5 | 2545 | 2.5% |
| 8.4 | 4728 | 4.6% |
| 8.3 | 8036 | |
| 8.2 | 4334 | 4.2% |
| 8.1 | 3932 | 3.8% |
| 8 | 6724 | |
| 7.9 | 2362 | 2.3% |
| 7.8 | 12677 |
cleanliness_score
Real number (ℝ)
High correlation
| Distinct | 14 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.2579611 |
| Minimum | 7.3 |
|---|---|
| Maximum | 9.1 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 805.4 KiB |
Quantile statistics
| Minimum | 7.3 |
|---|---|
| 5-th percentile | 7.4 |
| Q1 | 8 |
| median | 8.2 |
| Q3 | 8.7 |
| 95-th percentile | 8.8 |
| Maximum | 9.1 |
| Range | 1.8 |
| Interquartile range (IQR) | 0.7 |
Descriptive statistics
| Standard deviation | 0.4396936 |
|---|---|
| Coefficient of variation (CV) | 0.053244813 |
| Kurtosis | -0.38757973 |
| Mean | 8.2579611 |
| Median Absolute Deviation (MAD) | 0.3 |
| Skewness | -0.20031132 |
| Sum | 851197.6 |
| Variance | 0.19333046 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=14)
| Value | Count | Frequency (%) |
| 8.7 | 14579 | |
| 8.2 | 11627 | |
| 8.8 | 11199 | |
| 7.9 | 10388 | |
| 8.1 | 9453 | |
| 8.3 | 8890 | |
| 8 | 8831 | |
| 8.4 | 7723 | |
| 7.8 | 4919 | 4.8% |
| 7.3 | 4874 | 4.7% |
| Other values (4) | 10593 |
| Value | Count | Frequency (%) |
| 7.3 | 4874 | |
| 7.4 | 1975 | 1.9% |
| 7.5 | 1995 | 1.9% |
| 7.8 | 4919 | |
| 7.9 | 10388 | |
| 8 | 8831 | |
| 8.1 | 9453 | |
| 8.2 | 11627 | |
| 8.3 | 8890 | |
| 8.4 | 7723 |
| Value | Count | Frequency (%) |
| 9.1 | 4506 | 4.4% |
| 8.8 | 11199 | |
| 8.7 | 14579 | |
| 8.5 | 2117 | 2.1% |
| 8.4 | 7723 | |
| 8.3 | 8890 | |
| 8.2 | 11627 | |
| 8.1 | 9453 | |
| 8 | 8831 | |
| 7.9 | 10388 |
comfort_score
Real number (ℝ)
High correlation
| Distinct | 16 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.2565427 |
| Minimum | 7.3 |
|---|---|
| Maximum | 9.1 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 805.4 KiB |
Quantile statistics
| Minimum | 7.3 |
|---|---|
| 5-th percentile | 7.3 |
| Q1 | 8 |
| median | 8.2 |
| Q3 | 8.7 |
| 95-th percentile | 8.9 |
| Maximum | 9.1 |
| Range | 1.8 |
| Interquartile range (IQR) | 0.7 |
Descriptive statistics
| Standard deviation | 0.46494936 |
|---|---|
| Coefficient of variation (CV) | 0.056312838 |
| Kurtosis | -0.56190603 |
| Mean | 8.2565427 |
| Median Absolute Deviation (MAD) | 0.3 |
| Skewness | -0.14082429 |
| Sum | 851051.4 |
| Variance | 0.21617791 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=16)
| Value | Count | Frequency (%) |
| 8 | 13299 | |
| 7.9 | 11985 | |
| 8.2 | 10957 | |
| 8.8 | 10581 | |
| 8.1 | 9713 | |
| 8.9 | 8654 | |
| 8.3 | 6862 | |
| 7.3 | 6849 | |
| 8.5 | 5503 | 5.3% |
| 8.7 | 4728 | 4.6% |
| Other values (6) | 13945 |
| Value | Count | Frequency (%) |
| 7.3 | 6849 | |
| 7.4 | 1995 | 1.9% |
| 7.8 | 3443 | 3.3% |
| 7.9 | 11985 | |
| 8 | 13299 | |
| 8.1 | 9713 | |
| 8.2 | 10957 | |
| 8.3 | 6862 | |
| 8.4 | 1884 | 1.8% |
| 8.5 | 5503 |
| Value | Count | Frequency (%) |
| 9.1 | 2562 | 2.5% |
| 9 | 1944 | 1.9% |
| 8.9 | 8654 | |
| 8.8 | 10581 | |
| 8.7 | 4728 | |
| 8.6 | 2117 | 2.1% |
| 8.5 | 5503 | |
| 8.4 | 1884 | 1.8% |
| 8.3 | 6862 | |
| 8.2 | 10957 |
value_for_money_score
Real number (ℝ)
High correlation
| Distinct | 11 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.7126276 |
| Minimum | 7 |
|---|---|
| Maximum | 8.3 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 805.4 KiB |
Quantile statistics
| Minimum | 7 |
|---|---|
| 5-th percentile | 7.3 |
| Q1 | 7.4 |
| median | 7.7 |
| Q3 | 7.9 |
| 95-th percentile | 8.2 |
| Maximum | 8.3 |
| Range | 1.3 |
| Interquartile range (IQR) | 0.5 |
Descriptive statistics
| Standard deviation | 0.32440552 |
|---|---|
| Coefficient of variation (CV) | 0.042061608 |
| Kurtosis | -0.69888089 |
| Mean | 7.7126276 |
| Median Absolute Deviation (MAD) | 0.2 |
| Skewness | -0.17966144 |
| Sum | 794986.8 |
| Variance | 0.10523894 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=11)
| Value | Count | Frequency (%) |
| 7.9 | 24163 | |
| 7.4 | 13982 | |
| 7.5 | 10839 | |
| 8.1 | 10398 | |
| 7.6 | 9941 | |
| 7.7 | 9019 | 8.7% |
| 7.3 | 7076 | 6.9% |
| 7 | 4874 | 4.7% |
| 8.2 | 4728 | 4.6% |
| 8 | 4297 | 4.2% |
| Value | Count | Frequency (%) |
| 7 | 4874 | 4.7% |
| 7.3 | 7076 | 6.9% |
| 7.4 | 13982 | |
| 7.5 | 10839 | |
| 7.6 | 9941 | |
| 7.7 | 9019 | 8.7% |
| 7.9 | 24163 | |
| 8 | 4297 | 4.2% |
| 8.1 | 10398 | |
| 8.2 | 4728 | 4.6% |
| Value | Count | Frequency (%) |
| 8.3 | 3759 | 3.6% |
| 8.2 | 4728 | 4.6% |
| 8.1 | 10398 | |
| 8 | 4297 | 4.2% |
| 7.9 | 24163 | |
| 7.7 | 9019 | 8.7% |
| 7.6 | 9941 | |
| 7.5 | 10839 | |
| 7.4 | 13982 | |
| 7.3 | 7076 | 6.9% |
location_score
Real number (ℝ)
High correlation
| Distinct | 11 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9.1732751 |
| Minimum | 8.2 |
|---|---|
| Maximum | 9.7 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 805.4 KiB |
Quantile statistics
| Minimum | 8.2 |
|---|---|
| 5-th percentile | 8.6 |
| Q1 | 9 |
| median | 9.1 |
| Q3 | 9.4 |
| 95-th percentile | 9.6 |
| Maximum | 9.7 |
| Range | 1.5 |
| Interquartile range (IQR) | 0.4 |
Descriptive statistics
| Standard deviation | 0.30954624 |
|---|---|
| Coefficient of variation (CV) | 0.033744354 |
| Kurtosis | 0.42117248 |
| Mean | 9.1732751 |
| Median Absolute Deviation (MAD) | 0.2 |
| Skewness | -0.49357467 |
| Sum | 945544.5 |
| Variance | 0.095818878 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=11)
| Value | Count | Frequency (%) |
| 8.9 | 16389 | |
| 9.1 | 14855 | |
| 9 | 13837 | |
| 9.3 | 11502 | |
| 9.4 | 11122 | |
| 9.5 | 9817 | |
| 9.6 | 7471 | |
| 9.2 | 5923 | 5.7% |
| 8.6 | 5437 | 5.3% |
| 9.7 | 4728 | 4.6% |
| Value | Count | Frequency (%) |
| 8.2 | 1995 | 1.9% |
| 8.6 | 5437 | 5.3% |
| 8.9 | 16389 | |
| 9 | 13837 | |
| 9.1 | 14855 | |
| 9.2 | 5923 | 5.7% |
| 9.3 | 11502 | |
| 9.4 | 11122 | |
| 9.5 | 9817 | |
| 9.6 | 7471 |
| Value | Count | Frequency (%) |
| 9.7 | 4728 | 4.6% |
| 9.6 | 7471 | |
| 9.5 | 9817 | |
| 9.4 | 11122 | |
| 9.3 | 11502 | |
| 9.2 | 5923 | 5.7% |
| 9.1 | 14855 | |
| 9 | 13837 | |
| 8.9 | 16389 | |
| 8.6 | 5437 | 5.3% |
Crawled_date
Categorical
High correlation Imbalance
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 805.4 KiB |
| 2024-12-02 | |
|---|---|
| 2024-12-16 | 1735 |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2024-12-02 |
|---|---|
| 2nd row | 2024-12-02 |
| 3rd row | 2024-12-02 |
| 4th row | 2024-12-02 |
| 5th row | 2024-12-02 |
Common Values
| Value | Count | Frequency (%) |
| 2024-12-02 | 101341 | |
| 2024-12-16 | 1735 | 1.7% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2024-12-02 | 101341 | |
| 2024-12-16 | 1735 | 1.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 410569 | |
| - | 206152 | |
| 0 | 204417 | |
| 1 | 104811 | 10.2% |
| 4 | 103076 | 10.0% |
| 6 | 1735 | 0.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1030760 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 2 | 410569 | |
| - | 206152 | |
| 0 | 204417 | |
| 1 | 104811 | 10.2% |
| 4 | 103076 | 10.0% |
| 6 | 1735 | 0.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1030760 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 2 | 410569 | |
| - | 206152 | |
| 0 | 204417 | |
| 1 | 104811 | 10.2% |
| 4 | 103076 | 10.0% |
| 6 | 1735 | 0.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1030760 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 2 | 410569 | |
| - | 206152 | |
| 0 | 204417 | |
| 1 | 104811 | 10.2% |
| 4 | 103076 | 10.0% |
| 6 | 1735 | 0.2% |
title_word_count
Real number (ℝ)
| Distinct | 30 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.5156195 |
| Minimum | 1 |
|---|---|
| Maximum | 31 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 805.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 4 |
| Q3 | 8 |
| 95-th percentile | 17 |
| Maximum | 31 |
| Range | 30 |
| Interquartile range (IQR) | 7 |
Descriptive statistics
| Standard deviation | 5.1106655 |
|---|---|
| Coefficient of variation (CV) | 0.92658051 |
| Kurtosis | 1.7625261 |
| Mean | 5.5156195 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 1.4345584 |
| Sum | 568528 |
| Variance | 26.118902 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=30)
| Value | Count | Frequency (%) |
| 1 | 25775 | |
| 2 | 17582 | |
| 4 | 7344 | 7.1% |
| 5 | 6841 | 6.6% |
| 7 | 6627 | 6.4% |
| 6 | 6568 | 6.4% |
| 3 | 5139 | 5.0% |
| 8 | 4402 | 4.3% |
| 9 | 3810 | 3.7% |
| 10 | 3159 | 3.1% |
| Other values (20) | 15829 |
| Value | Count | Frequency (%) |
| 1 | 25775 | |
| 2 | 17582 | |
| 3 | 5139 | 5.0% |
| 4 | 7344 | 7.1% |
| 5 | 6841 | 6.6% |
| 6 | 6568 | 6.4% |
| 7 | 6627 | 6.4% |
| 8 | 4402 | 4.3% |
| 9 | 3810 | 3.7% |
| 10 | 3159 | 3.1% |
| Value | Count | Frequency (%) |
| 31 | 1 | < 0.1% |
| 29 | 2 | < 0.1% |
| 28 | 6 | < 0.1% |
| 27 | 27 | < 0.1% |
| 26 | 48 | < 0.1% |
| 25 | 130 | 0.1% |
| 24 | 250 | 0.2% |
| 23 | 718 | |
| 22 | 393 | |
| 21 | 550 |
text_word_count
Real number (ℝ)
| Distinct | 419 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 37.370959 |
| Minimum | 1 |
|---|---|
| Maximum | 666 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 805.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 4 |
| Q1 | 11 |
| median | 24 |
| Q3 | 49 |
| 95-th percentile | 113 |
| Maximum | 666 |
| Range | 665 |
| Interquartile range (IQR) | 38 |
Descriptive statistics
| Standard deviation | 40.749444 |
|---|---|
| Coefficient of variation (CV) | 1.090404 |
| Kurtosis | 15.877065 |
| Mean | 37.370959 |
| Median Absolute Deviation (MAD) | 16 |
| Skewness | 3.0554809 |
| Sum | 3852049 |
| Variance | 1660.5172 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 7 | 2997 | 2.9% |
| 5 | 2990 | 2.9% |
| 6 | 2906 | 2.8% |
| 11 | 2812 | 2.7% |
| 9 | 2693 | 2.6% |
| 8 | 2564 | 2.5% |
| 12 | 2548 | 2.5% |
| 4 | 2546 | 2.5% |
| 10 | 2452 | 2.4% |
| 14 | 2384 | 2.3% |
| Other values (409) | 76184 |
| Value | Count | Frequency (%) |
| 1 | 668 | 0.6% |
| 2 | 1751 | |
| 3 | 1909 | |
| 4 | 2546 | |
| 5 | 2990 | |
| 6 | 2906 | |
| 7 | 2997 | |
| 8 | 2564 | |
| 9 | 2693 | |
| 10 | 2452 |
| Value | Count | Frequency (%) |
| 666 | 1 | |
| 568 | 1 | |
| 527 | 1 | |
| 510 | 1 | |
| 503 | 1 | |
| 493 | 1 | |
| 491 | 1 | |
| 479 | 1 | |
| 471 | 1 | |
| 469 | 1 |
Deviation.of.star.ratings
Real number (ℝ)
Zeros
| Distinct | 84 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.297985 |
| Minimum | 0 |
|---|---|
| Maximum | 7.7 |
| Zeros | 2958 |
| Zeros (%) | 2.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 805.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.1 |
| Q1 | 0.4 |
| median | 1 |
| Q3 | 1.7 |
| 95-th percentile | 3.9 |
| Maximum | 7.7 |
| Range | 7.7 |
| Interquartile range (IQR) | 1.3 |
Descriptive statistics
| Standard deviation | 1.268132 |
|---|---|
| Coefficient of variation (CV) | 0.97700054 |
| Kurtosis | 5.4931347 |
| Mean | 1.297985 |
| Median Absolute Deviation (MAD) | 0.6 |
| Skewness | 2.124388 |
| Sum | 133791.1 |
| Variance | 1.6081588 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.6 | 9564 | 9.3% |
| 0.4 | 8601 | 8.3% |
| 0.3 | 7017 | 6.8% |
| 1.3 | 6405 | 6.2% |
| 1.4 | 6368 | 6.2% |
| 1 | 4527 | 4.4% |
| 0.7 | 4209 | 4.1% |
| 0.1 | 4164 | 4.0% |
| 1.6 | 3218 | 3.1% |
| 0.3 | 3193 | 3.1% |
| Other values (74) | 45810 |
| Value | Count | Frequency (%) |
| 0 | 2958 | 2.9% |
| 0.1 | 4164 | |
| 0.2 | 600 | 0.6% |
| 0.2 | 2649 | 2.6% |
| 0.3 | 7017 | |
| 0.3 | 3193 | 3.1% |
| 0.4 | 8601 | |
| 0.5 | 930 | 0.9% |
| 0.6 | 9564 | |
| 0.6 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 7.7 | 17 | < 0.1% |
| 7.6 | 18 | < 0.1% |
| 7.4 | 99 | 0.1% |
| 7.3 | 54 | 0.1% |
| 7.2 | 9 | < 0.1% |
| 7.1 | 69 | 0.1% |
| 7 | 90 | 0.1% |
| 6.9 | 120 | 0.1% |
| 6.8 | 162 | 0.2% |
| 6.7 | 487 |
Time_lapsed
Real number (ℝ)
| Distinct | 1100 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 504.78416 |
| Minimum | -2 |
|---|---|
| Maximum | 1097 |
| Zeros | 70 |
| Zeros (%) | 0.1% |
| Negative | 28 |
| Negative (%) | < 0.1% |
| Memory size | 805.4 KiB |
Quantile statistics
| Minimum | -2 |
|---|---|
| 5-th percentile | 33 |
| Q1 | 197 |
| median | 504 |
| Q3 | 804 |
| 95-th percentile | 1018 |
| Maximum | 1097 |
| Range | 1099 |
| Interquartile range (IQR) | 607 |
Descriptive statistics
| Standard deviation | 330.64121 |
|---|---|
| Coefficient of variation (CV) | 0.65501502 |
| Kurtosis | -1.2597732 |
| Mean | 504.78416 |
| Median Absolute Deviation (MAD) | 303 |
| Skewness | 0.064456178 |
| Sum | 52031132 |
| Variance | 109323.61 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 22 | 1138 | 1.1% |
| 33 | 935 | 0.9% |
| 34 | 905 | 0.9% |
| 41 | 900 | 0.9% |
| 39 | 874 | 0.8% |
| 21 | 751 | 0.7% |
| 35 | 704 | 0.7% |
| 42 | 517 | 0.5% |
| 38 | 494 | 0.5% |
| 40 | 446 | 0.4% |
| Other values (1090) | 95412 |
| Value | Count | Frequency (%) |
| -2 | 2 | < 0.1% |
| -1 | 26 | < 0.1% |
| 0 | 70 | |
| 1 | 70 | |
| 2 | 101 | |
| 3 | 98 | |
| 4 | 81 | |
| 5 | 57 | |
| 6 | 79 | |
| 7 | 118 |
| Value | Count | Frequency (%) |
| 1097 | 3 | < 0.1% |
| 1096 | 41 | < 0.1% |
| 1095 | 53 | 0.1% |
| 1094 | 57 | 0.1% |
| 1093 | 80 | |
| 1092 | 152 | |
| 1091 | 89 | |
| 1090 | 80 | |
| 1089 | 78 | |
| 1088 | 70 |
Depth
Real number (ℝ)
High correlation
| Distinct | 91515 |
|---|---|
| Distinct (%) | 88.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.6673556 |
| Minimum | 0.012601162 |
|---|---|
| Maximum | 4.1688739 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 805.4 KiB |
Quantile statistics
| Minimum | 0.012601162 |
|---|---|
| 5-th percentile | 0.24036735 |
| Q1 | 3.9315144 |
| median | 4.1088943 |
| Q3 | 4.1469427 |
| 95-th percentile | 4.1630048 |
| Maximum | 4.1688739 |
| Range | 4.1562727 |
| Interquartile range (IQR) | 0.21542832 |
Descriptive statistics
| Standard deviation | 1.0835643 |
|---|---|
| Coefficient of variation (CV) | 0.29546202 |
| Kurtosis | 5.224727 |
| Mean | 3.6673556 |
| Median Absolute Deviation (MAD) | 0.04869006 |
| Skewness | -2.5800111 |
| Sum | 378016.35 |
| Variance | 1.1741116 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.7336058717 | 100 | 0.1% |
| 0.07129944682 | 100 | 0.1% |
| 0.327605505 | 100 | 0.1% |
| 3.436142792 | 100 | 0.1% |
| 0.2729918326 | 100 | 0.1% |
| 0.08027615348 | 100 | 0.1% |
| 0.09504141834 | 100 | 0.1% |
| 0.1977737147 | 100 | 0.1% |
| 0.080685688 | 100 | 0.1% |
| 0.3522561707 | 100 | 0.1% |
| Other values (91505) | 102076 |
| Value | Count | Frequency (%) |
| 0.01260116246 | 1 | |
| 0.01914650691 | 1 | |
| 0.02194744686 | 1 | |
| 0.02298841269 | 1 | |
| 0.02486463467 | 1 | |
| 0.025432713 | 1 | |
| 0.02629962357 | 1 | |
| 0.02654172296 | 1 | |
| 0.02950573643 | 1 | |
| 0.02974145401 | 1 |
| Value | Count | Frequency (%) |
| 4.168873903 | 1 | |
| 4.168804929 | 1 | |
| 4.168781023 | 1 | |
| 4.168646412 | 1 | |
| 4.16864324 | 1 | |
| 4.168638399 | 1 | |
| 4.16857928 | 1 | |
| 4.168541557 | 1 | |
| 4.168530101 | 1 | |
| 4.16852448 | 1 |
Breadth
Real number (ℝ)
High correlation
| Distinct | 91515 |
|---|---|
| Distinct (%) | 88.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.44844776 |
| Minimum | 0.00022905809 |
|---|---|
| Maximum | 5.8055472 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 805.4 KiB |
Quantile statistics
| Minimum | 0.00022905809 |
|---|---|
| 5-th percentile | 0.005378859 |
| Q1 | 0.019625352 |
| median | 0.049508995 |
| Q3 | 0.239119 |
| 95-th percentile | 3.2482945 |
| Maximum | 5.8055472 |
| Range | 5.8053182 |
| Interquartile range (IQR) | 0.21949365 |
Descriptive statistics
| Standard deviation | 0.95668542 |
|---|---|
| Coefficient of variation (CV) | 2.1333263 |
| Kurtosis | 5.1430972 |
| Mean | 0.44844776 |
| Median Absolute Deviation (MAD) | 0.039350876 |
| Skewness | 2.5298934 |
| Sum | 46224.202 |
| Variance | 0.91524699 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 2.811815413 | 100 | 0.1% |
| 3.272018845 | 100 | 0.1% |
| 3.021920156 | 100 | 0.1% |
| 2.051197399 | 100 | 0.1% |
| 3.136129587 | 100 | 0.1% |
| 3.265073295 | 100 | 0.1% |
| 3.248287686 | 100 | 0.1% |
| 3.145693353 | 100 | 0.1% |
| 3.260204296 | 100 | 0.1% |
| 3.086971247 | 100 | 0.1% |
| Other values (91505) | 102076 |
| Value | Count | Frequency (%) |
| 0.000229058089 | 1 | < 0.1% |
| 0.0002640175533 | 1 | < 0.1% |
| 0.0002717905476 | 1 | < 0.1% |
| 0.0002735136346 | 4 | < 0.1% |
| 0.0002749332064 | 1 | < 0.1% |
| 0.0002860301209 | 2 | < 0.1% |
| 0.0002949128143 | 1 | < 0.1% |
| 0.0002969371781 | 12 | |
| 0.0002971830134 | 2 | < 0.1% |
| 0.0003024245461 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 5.805547214 | 1 | < 0.1% |
| 5.403308331 | 7 | < 0.1% |
| 5.097892004 | 1 | < 0.1% |
| 5.068863578 | 1 | < 0.1% |
| 5.045583762 | 1 | < 0.1% |
| 5.044899191 | 1 | < 0.1% |
| 5.018399874 | 1 | < 0.1% |
| 4.968003829 | 24 | |
| 4.955974295 | 1 | < 0.1% |
| 4.938898305 | 23 |
Interactions
Correlations
| Average_Rating | Breadth | Crawled_date | Depth | Deviation.of.star.ratings | Helpfulness | Hotel_Name | Num_of_Ratings | Rating | Time_lapsed | cleanliness_score | comfort_score | employee_friendliness_score | facility_score | hotel_grade | is_photo | location_score | text_word_count | title_word_count | value_for_money_score | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Average_Rating | 1.000 | 0.103 | 0.194 | -0.078 | -0.023 | -0.031 | 1.000 | -0.302 | 0.305 | -0.029 | 0.922 | 0.889 | 0.845 | 0.948 | 0.492 | 0.087 | 0.179 | -0.048 | 0.026 | 0.720 |
| Breadth | 0.103 | 1.000 | 0.035 | -0.923 | 0.056 | 0.027 | 0.227 | -0.045 | -0.063 | -0.326 | 0.053 | 0.068 | 0.009 | 0.115 | 0.135 | 0.063 | -0.107 | 0.425 | 0.113 | 0.031 |
| Crawled_date | 0.194 | 0.035 | 1.000 | 0.064 | 0.056 | 0.000 | 1.000 | 0.176 | 0.016 | 0.037 | 0.258 | 0.261 | 0.287 | 0.296 | 0.168 | 0.000 | 0.259 | 0.022 | 0.057 | 0.627 |
| Depth | -0.078 | -0.923 | 0.064 | 1.000 | -0.079 | -0.027 | 0.212 | 0.037 | 0.073 | 0.311 | -0.033 | -0.043 | 0.030 | -0.094 | 0.131 | 0.050 | 0.136 | -0.408 | -0.103 | -0.039 |
| Deviation.of.star.ratings | -0.023 | 0.056 | 0.056 | -0.079 | 1.000 | -0.035 | 0.191 | -0.120 | -0.030 | 0.048 | 0.009 | 0.002 | 0.035 | 0.006 | 0.130 | 0.050 | -0.068 | 0.040 | -0.075 | 0.008 |
| Helpfulness | -0.031 | 0.027 | 0.000 | -0.027 | -0.035 | 1.000 | 0.032 | -0.002 | -0.077 | 0.048 | -0.018 | -0.017 | -0.037 | -0.024 | 0.010 | 0.021 | -0.007 | 0.128 | 0.013 | -0.015 |
| Hotel_Name | 1.000 | 0.227 | 1.000 | 0.212 | 0.191 | 0.032 | 1.000 | 1.000 | 0.167 | 0.169 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 0.145 | 1.000 | 0.043 | 0.066 | 1.000 |
| Num_of_Ratings | -0.302 | -0.045 | 0.176 | 0.037 | -0.120 | -0.002 | 1.000 | 1.000 | -0.078 | -0.049 | -0.359 | -0.243 | -0.304 | -0.318 | 0.592 | 0.111 | 0.342 | 0.013 | 0.024 | -0.363 |
| Rating | 0.305 | -0.063 | 0.016 | 0.073 | -0.030 | -0.077 | 0.167 | -0.078 | 1.000 | -0.023 | 0.288 | 0.287 | 0.272 | 0.296 | 0.129 | 0.081 | 0.082 | -0.200 | -0.005 | 0.212 |
| Time_lapsed | -0.029 | -0.326 | 0.037 | 0.311 | 0.048 | 0.048 | 0.169 | -0.049 | -0.023 | 1.000 | 0.001 | 0.009 | 0.036 | -0.031 | 0.099 | 0.026 | 0.028 | -0.051 | -0.048 | 0.058 |
| cleanliness_score | 0.922 | 0.053 | 0.258 | -0.033 | 0.009 | -0.018 | 1.000 | -0.359 | 0.288 | 0.001 | 1.000 | 0.961 | 0.851 | 0.951 | 0.531 | 0.083 | 0.113 | -0.045 | 0.018 | 0.757 |
| comfort_score | 0.889 | 0.068 | 0.261 | -0.043 | 0.002 | -0.017 | 1.000 | -0.243 | 0.287 | 0.009 | 0.961 | 1.000 | 0.821 | 0.943 | 0.469 | 0.061 | 0.131 | -0.039 | 0.023 | 0.664 |
| employee_friendliness_score | 0.845 | 0.009 | 0.287 | 0.030 | 0.035 | -0.037 | 1.000 | -0.304 | 0.272 | 0.036 | 0.851 | 0.821 | 1.000 | 0.821 | 0.394 | 0.098 | 0.144 | -0.058 | 0.021 | 0.706 |
| facility_score | 0.948 | 0.115 | 0.296 | -0.094 | 0.006 | -0.024 | 1.000 | -0.318 | 0.296 | -0.031 | 0.951 | 0.943 | 0.821 | 1.000 | 0.654 | 0.089 | 0.096 | -0.042 | 0.017 | 0.704 |
| hotel_grade | 0.492 | 0.135 | 0.168 | 0.131 | 0.130 | 0.010 | 1.000 | 0.592 | 0.129 | 0.099 | 0.531 | 0.469 | 0.394 | 0.654 | 1.000 | 0.054 | 0.412 | 0.018 | 0.024 | 0.332 |
| is_photo | 0.087 | 0.063 | 0.000 | 0.050 | 0.050 | 0.021 | 0.145 | 0.111 | 0.081 | 0.026 | 0.083 | 0.061 | 0.098 | 0.089 | 0.054 | 1.000 | 0.072 | 0.088 | 0.109 | 0.076 |
| location_score | 0.179 | -0.107 | 0.259 | 0.136 | -0.068 | -0.007 | 1.000 | 0.342 | 0.082 | 0.028 | 0.113 | 0.131 | 0.144 | 0.096 | 0.412 | 0.072 | 1.000 | -0.009 | 0.041 | 0.011 |
| text_word_count | -0.048 | 0.425 | 0.022 | -0.408 | 0.040 | 0.128 | 0.043 | 0.013 | -0.200 | -0.051 | -0.045 | -0.039 | -0.058 | -0.042 | 0.018 | 0.088 | -0.009 | 1.000 | 0.212 | -0.040 |
| title_word_count | 0.026 | 0.113 | 0.057 | -0.103 | -0.075 | 0.013 | 0.066 | 0.024 | -0.005 | -0.048 | 0.018 | 0.023 | 0.021 | 0.017 | 0.024 | 0.109 | 0.041 | 0.212 | 1.000 | 0.016 |
| value_for_money_score | 0.720 | 0.031 | 0.627 | -0.039 | 0.008 | -0.015 | 1.000 | -0.363 | 0.212 | 0.058 | 0.757 | 0.664 | 0.706 | 0.704 | 0.332 | 0.076 | 0.011 | -0.040 | 0.016 | 1.000 |
Missing values
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
Sample
| Hotel_Name | Review_Text | Posted_Date | Rating | Average_Rating | Num_of_Ratings | Helpfulness | is_photo | review_title | hotel_grade | employee_friendliness_score | facility_score | cleanliness_score | comfort_score | value_for_money_score | location_score | Crawled_date | title_word_count | text_word_count | Deviation.of.star.ratings | Time_lapsed | Depth | Breadth | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | studios2let | Perfect location with good connections and shops and pubs | 2024-05-01 | 10.0 | 7.6 | 11670 | 0 | 0 | Exceptional | 3 | 8.3 | 7.5 | 7.9 | 7.8 | 7.6 | 9.3 | 2024-12-02 | 1 | 9 | 2.4 | 215 | 4.160758 | 0.014384 |
| 1 | studios2let | The room had everything you needed Near to amenities, was good room for price just needs little updatingThe bed was so hard it felt like sleeping on a hard floor, you had to make sure you had something on your feet as flooring pinched you feet needs changing | 2024-12-02 | 8.0 | 7.6 | 11670 | 0 | 0 | Very good | 3 | 8.3 | 7.5 | 7.9 | 7.8 | 7.6 | 9.3 | 2024-12-02 | 2 | 48 | 0.4 | 0 | 4.028748 | 0.106661 |
| 2 | studios2let | Conveniently nearby St Pancras, very small but clean and pleasant room first floor with small balcony to street side Interesting areaLuggage service can be improved by offering to lock luggage up instead of it just being put into the hall with all risks on the guests | 2024-12-01 | 8.0 | 7.6 | 11670 | 0 | 0 | Convenient location | 3 | 8.3 | 7.5 | 7.9 | 7.8 | 7.6 | 9.3 | 2024-12-02 | 2 | 46 | 0.4 | 1 | 4.145647 | 0.015296 |
| 3 | studios2let | Reception staffed 24 hours a dayAll good | 2024-12-01 | 9.0 | 7.6 | 11670 | 0 | 0 | Peaceful position in an elegant street close to 3 major stations and the Bloomsbury area | 3 | 8.3 | 7.5 | 7.9 | 7.8 | 7.6 | 9.3 | 2024-12-02 | 15 | 7 | 1.4 | 1 | 4.152822 | 0.018400 |
| 4 | studios2let | Very convenient to Kings Cross and the cityA little dated could do with a lick of paint | 2024-11-30 | 8.0 | 7.6 | 11670 | 0 | 0 | Great little gem in the city centre | 3 | 8.3 | 7.5 | 7.9 | 7.8 | 7.6 | 9.3 | 2024-12-02 | 7 | 17 | 0.4 | 2 | 3.981752 | 0.114333 |
| 5 | studios2let | Located in a quiet area but close to Kings Cross station so getting around was easy Several little pubs nearby for dining and some good coffee shops tooThere is no lift so dragging a heavy suitcase up and down stairs was challenging We had booked a room with terrace but the outdoor space was really minuscule not what we had expected from the photos | 2024-11-30 | 7.0 | 7.6 | 11670 | 0 | 0 | Convenient, quiet location | 3 | 8.3 | 7.5 | 7.9 | 7.8 | 7.6 | 9.3 | 2024-12-02 | 3 | 65 | 0.6 | 2 | 4.050882 | 0.052436 |
| 6 | studios2let | Its spacious, good value and so very quiet for LondonYou sometimes have to wriggle the loo flusher to stop it running and running | 2024-11-30 | 9.0 | 7.6 | 11670 | 0 | 0 | Superb | 3 | 8.3 | 7.5 | 7.9 | 7.8 | 7.6 | 9.3 | 2024-12-02 | 1 | 23 | 1.4 | 2 | 4.151421 | 0.017526 |
| 7 | studios2let | LocationLot of stairs bad knee | 2024-11-29 | 9.0 | 7.6 | 11670 | 0 | 0 | Ideal location for travelling round | 3 | 8.3 | 7.5 | 7.9 | 7.8 | 7.6 | 9.3 | 2024-12-02 | 5 | 5 | 1.4 | 3 | 4.143119 | 0.012692 |
| 8 | studios2let | Location was great, so near the stationWe were on the top floor, six flights of stairs and no lift\r\nHeating was on 247 full temperature and no means of reducing it | 2024-11-29 | 7.0 | 7.6 | 11670 | 0 | 0 | Perfect location, | 3 | 8.3 | 7.5 | 7.9 | 7.8 | 7.6 | 9.3 | 2024-12-02 | 2 | 31 | 0.6 | 3 | 3.949841 | 0.160883 |
| 9 | studios2let | The location which is excellent for public transport and local dining \r\nFriendly staffed reception where we could leave our travel bags all day after checking outThe climb up 3 flights of stairs was exhausting but it was our choice\r\nIt was a small room and the kitchen facilities were very sparse but we didnt need them | 2024-11-28 | 8.0 | 7.6 | 11670 | 0 | 0 | Ideal accommodation for a short stay in London near St Pancreas station | 3 | 8.3 | 7.5 | 7.9 | 7.8 | 7.6 | 9.3 | 2024-12-02 | 12 | 57 | 0.4 | 4 | 4.119746 | 0.060710 |
| Hotel_Name | Review_Text | Posted_Date | Rating | Average_Rating | Num_of_Ratings | Helpfulness | is_photo | review_title | hotel_grade | employee_friendliness_score | facility_score | cleanliness_score | comfort_score | value_for_money_score | location_score | Crawled_date | title_word_count | text_word_count | Deviation.of.star.ratings | Time_lapsed | Depth | Breadth | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 103066 | montanahotel | Perfect Location | 2023-09-02 | 10.0 | 7.8 | 6248 | 0 | 0 | Lovely staff | 3 | 9.0 | 7.7 | 8.2 | 8.2 | 8.0 | 9.4 | 2024-12-16 | 2 | 2 | 2.2 | 471 | 0.284412 | 3.274274 |
| 103067 | montanahotel | It was good enoughDelayed check in, cracked basin in bathroom, water pressure poor Everything else was fine | 2023-07-11 | 6.0 | 7.8 | 6248 | 0 | 0 | Not a bad place to stay if its where you need to be | 3 | 9.0 | 7.7 | 8.2 | 8.2 | 8.0 | 9.4 | 2024-12-16 | 13 | 17 | 1.8 | 524 | 0.033047 | 3.061864 |
| 103068 | montanahotel | locationhot room, shower didnt drain, broken sink | 2023-07-01 | 5.0 | 7.8 | 6248 | 0 | 0 | Great location and generally clean spot but the place is a bit a dated and the basement room was damp, hot and a bit mus | 3 | 9.0 | 7.7 | 8.2 | 8.2 | 8.0 | 9.4 | 2024-12-16 | 25 | 7 | 2.8 | 534 | 0.082553 | 4.014645 |
| 103069 | montanahotel | Good to have teacoffee and a fridge in the roomThe building is beautiful but the interior decor leaves a lot to be desired The hotel is Indian in styleredgoldfaded wallpaper and threadbare carpetsthe room was OK but again needed updating We were in the basement with no viewonly rubbish out of the window There was no hot breakfast so only cereals, fruit and pastriesbut it was in a pleasant locationnear the tube and shopspubs etconly a short walk to the Natural History museum | 2023-04-25 | 6.0 | 7.8 | 6248 | 0 | 0 | Lovely building with quite a grand entrancelet down by the interiorfine for overnight stay | 3 | 9.0 | 7.7 | 8.2 | 8.2 | 8.0 | 9.4 | 2024-12-16 | 14 | 83 | 1.8 | 601 | 0.022988 | 4.066392 |
| 103070 | montanahotel | locationwater pressure was non existent\r\ndespite several request to address the problem | 2023-03-25 | 3.0 | 7.8 | 6248 | 0 | 0 | while the staff was nice They did very little to remedy the lack of shower and hot water problem we had | 3 | 9.0 | 7.7 | 8.2 | 8.2 | 8.0 | 9.4 | 2024-12-16 | 22 | 12 | 4.8 | 632 | 0.082978 | 4.013796 |
| 103071 | montanahotel | Convenient and classy The staff are excellent people, and Light of India is a fantastic restaurant I would certainly stay againNA | 2022-12-28 | 10.0 | 7.8 | 6248 | 0 | 0 | Highly recommend this little gem situated in my favourite part of town | 3 | 9.0 | 7.7 | 8.2 | 8.2 | 8.0 | 9.4 | 2024-12-16 | 12 | 21 | 2.2 | 719 | 0.067642 | 4.028017 |
| 103072 | montanahotel | lovely atmosphere, extremely friendly and helpful staff | 2022-07-01 | 10.0 | 7.8 | 6248 | 0 | 0 | Perfect location for our visit to the Royal Albert Hall and the Natural History Museum would | 3 | 9.0 | 7.7 | 8.2 | 8.2 | 8.0 | 9.4 | 2024-12-16 | 16 | 7 | 2.2 | 899 | 0.088096 | 3.441931 |
| 103073 | montanahotel | It was a single room, a little small but it was fine for 1 person, it had everything I needed | 2022-06-28 | 10.0 | 7.8 | 6248 | 0 | 1 | The staff were very friendly and helpful The position was perfect for sightseeing | 3 | 9.0 | 7.7 | 8.2 | 8.2 | 8.0 | 9.4 | 2024-12-16 | 13 | 20 | 2.2 | 902 | 0.083923 | 4.012930 |
| 103074 | montanahotel | Very clean and well maintainedThe rooms are very nice and comfortable with staffs professionalismThe food are delicious,nice breakfast,lunch ,dinner and the cocktails are exceptionalNotting much just that theres no parking | 2022-02-16 | 10.0 | 7.8 | 6248 | 0 | 1 | Myself and my wife really enjoy our stay at this hotel,we love the service and all the staffs are amazingLooking forwar | 3 | 9.0 | 7.7 | 8.2 | 8.2 | 8.0 | 9.4 | 2024-12-16 | 21 | 30 | 2.2 | 1034 | 0.024865 | 3.068829 |
| 103075 | montanahotel | The staff were very friendly and helpful Especially Kampas The hotel was very clean and the fact that they had a wonderful Indian restaurant as part of it was amazing Best Vindaloo everShower a tad small but adequate xx | 2022-02-06 | 10.0 | 7.8 | 6248 | 0 | 1 | Loved every minute we will be back Xxx | 3 | 9.0 | 7.7 | 8.2 | 8.2 | 8.0 | 9.4 | 2024-12-16 | 8 | 39 | 2.2 | 1044 | 0.035488 | 4.055666 |
Duplicate rows
Most frequently occurring
| Hotel_Name | Review_Text | Posted_Date | Rating | Average_Rating | Num_of_Ratings | Helpfulness | is_photo | review_title | hotel_grade | employee_friendliness_score | facility_score | cleanliness_score | comfort_score | value_for_money_score | location_score | Crawled_date | title_word_count | text_word_count | Deviation.of.star.ratings | Time_lapsed | Depth | Breadth | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | blakemore | Breakfast was lovely, room was good and a nice showerIt was a little bit noisy but to be expected in city location | 2024-10-21 | 9.0 | 8.3 | 12340 | 0 | 0 | nice stay | 4 | 8.7 | 8.3 | 8.7 | 8.8 | 8.1 | 8.9 | 2024-12-02 | 2 | 22 | 0.7 | 42 | 0.272992 | 3.136130 | 100 |
| 5 | blakemore | Clean, nice big room, comfy bed | 2024-10-24 | 9.0 | 8.3 | 12340 | 0 | 0 | Wish wed stayed longer | 4 | 8.7 | 8.3 | 8.7 | 8.8 | 8.1 | 8.9 | 2024-12-02 | 4 | 6 | 0.7 | 39 | 3.436143 | 2.051197 | 100 |
| 8 | blakemore | Great location Very friendly and helpful concierge Comfortable room and bed Decent breakfastDidnt like the position of room lower ground floor Most of the staff at reception werent very friendly excluding one guy but cant remember his name In general they just chatted among themselves and didnt greet guests except when checking them in | 2024-10-24 | 7.0 | 8.3 | 12340 | 0 | 0 | Comfortable hotel in a good location | 4 | 8.7 | 8.3 | 8.7 | 8.8 | 8.1 | 8.9 | 2024-12-02 | 6 | 55 | 1.3 | 39 | 0.082514 | 3.261759 | 100 |
| 13 | blakemore | Handy and good valueThe twin beds had no space between them | 2024-10-22 | 8.0 | 8.3 | 12340 | 0 | 0 | Enjoyable, modern and clean | 4 | 8.7 | 8.3 | 8.7 | 8.8 | 8.1 | 8.9 | 2024-12-02 | 4 | 11 | 0.3 | 41 | 3.400304 | 2.059872 | 100 |
| 14 | blakemore | I liked afternoon drinks in the restaurant | 2024-10-22 | 8.0 | 8.3 | 12340 | 0 | 0 | Very good | 4 | 8.7 | 8.3 | 8.7 | 8.8 | 8.1 | 8.9 | 2024-12-02 | 2 | 7 | 0.3 | 41 | 0.818475 | 2.830759 | 100 |
| 17 | blakemore | Location was great, easy to get there Room was just as the pictures, no surprise, comfortable bed, clean room Nice staffNA | 2024-10-21 | 9.0 | 8.3 | 12340 | 0 | 0 | The hotel is in amazing place just a 2 min walk from Hyde park Neighbourhood was nice, quiet and clean Staff was nice, | 4 | 8.7 | 8.3 | 8.7 | 8.8 | 8.1 | 8.9 | 2024-12-02 | 23 | 21 | 0.7 | 42 | 0.267678 | 3.137761 | 100 |
| 20 | blakemore | Lovely outside area \r\nGreat size bed really comfortableNo mini bar in room fridge was empty No room service after eleven or didnt seem to be as no one answered the phone | 2024-10-25 | 8.0 | 8.3 | 12340 | 0 | 0 | Comfortable and clean very good location | 4 | 8.7 | 8.3 | 8.7 | 8.8 | 8.1 | 8.9 | 2024-12-02 | 7 | 32 | 0.3 | 38 | 0.130445 | 3.229430 | 100 |
| 23 | blakemore | The breakfast was a bit bland but I guess thats a cultural differenceMore variety in the breakfast or perhaps a different breakfast menu for different days | 2024-10-24 | 8.0 | 8.3 | 12340 | 0 | 0 | Excellent overall Very friendly staff | 4 | 8.7 | 8.3 | 8.7 | 8.8 | 8.1 | 8.9 | 2024-12-02 | 5 | 26 | 0.3 | 39 | 0.152382 | 3.215152 | 100 |
| 26 | blakemore | The property was wellmaintained and very clean the room was as described and well appointed We had daily housekeeping and dining room and bar were comfortable and relaxingOur room wouldnt cool when we first arrived but that was quickly corrected by staff Other than that I have nothing bad to say about the hotel | 2024-10-24 | 9.0 | 8.3 | 12340 | 0 | 0 | We would definitely stay here again and would certainly recommend it to friends and family traveling to London | 4 | 8.7 | 8.3 | 8.7 | 8.8 | 8.1 | 8.9 | 2024-12-02 | 18 | 54 | 0.7 | 39 | 0.103976 | 3.247377 | 100 |
| 29 | blakemore | The wait for breakfast table can sometimes be very long, some food items and cups run out and the staff manning the breakfast room is on the rude side | 2024-10-22 | 8.0 | 8.3 | 12340 | 0 | 0 | Great location but some small improvements needed | 4 | 8.7 | 8.3 | 8.7 | 8.8 | 8.1 | 8.9 | 2024-12-02 | 7 | 29 | 0.3 | 41 | 0.154130 | 3.213937 | 100 |